﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Studentyemian/Student.Master" AutoEventWireup="true" CodeBehind="stulianxi.aspx.cs" Inherits="zlh.Studentyemian.stulianxi" %>
<asp:Content ID="Content1" ContentPlaceHolderID="stuConPlaHd" runat="server">
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Label ID="Label1" runat="server" CssClass="word" Text="名字："></asp:Label>
        <asp:TextBox ID="TextBox1" runat="server" CssClass="textbox"></asp:TextBox>
        <asp:Button ID="Button2" runat="server" CssClass="button" Text="确认查询" />
    </p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" HorizontalAlign="Center" Height="101px" Width="729px">
        <Columns>
            <asp:BoundField DataField="stuNO" HeaderText="stuNO" SortExpression="stuNO" />
            <asp:BoundField DataField="stuNAME" HeaderText="stuNAME" SortExpression="stuNAME" />
            <asp:BoundField DataField="telephone" HeaderText="telephone" SortExpression="telephone" />
            <asp:BoundField DataField="duanhao" HeaderText="duanhao" SortExpression="duanhao" />
            <asp:BoundField DataField="qqnumber" HeaderText="qqnumber" SortExpression="qqnumber" />
            <asp:BoundField DataField="weixinnumber" HeaderText="weixinnumber" SortExpression="weixinnumber" />
        </Columns>
        <HeaderStyle CssClass="gridxiewHeaderstyle" />
        <RowStyle CssClass="gridviewrowstyle" />
    </asp:GridView>
    <p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString12 %>" SelectCommand="SELECT * FROM [stulianxifshi] WHERE ([stuNAME] = @stuNAME)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="stuNAME" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    </p>
    <p>
        &nbsp;</p>
<p>
        &nbsp;</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Label ID="stuno" runat="server" CssClass="word" Text="学号："></asp:Label>
        <asp:TextBox ID="TextBox2" runat="server" CssClass="textbox"></asp:TextBox>
        <asp:Button ID="Button3" runat="server" CssClass="button" Text="确认查询" />
    &nbsp;&nbsp; </p>
    <p>
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" HorizontalAlign="Center" style="margin-top: 0px" Width="805px">
            <Columns>
                <asp:BoundField DataField="stuNO" HeaderText="stuNO" SortExpression="stuNO" />
                <asp:BoundField DataField="stuNAME" HeaderText="stuNAME" SortExpression="stuNAME" />
                <asp:BoundField DataField="telephone" HeaderText="telephone" SortExpression="telephone" />
                <asp:BoundField DataField="duanhao" HeaderText="duanhao" SortExpression="duanhao" />
                <asp:BoundField DataField="qqnumber" HeaderText="qqnumber" SortExpression="qqnumber" />
                <asp:BoundField DataField="weixinnumber" HeaderText="weixinnumber" SortExpression="weixinnumber" />
            </Columns>
            <HeaderStyle CssClass="gridxiewHeaderstyle" />
            <RowStyle CssClass="gridviewrowstyle" />
        </asp:GridView>
    </p>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString13 %>" SelectCommand="SELECT * FROM [stulianxifshi] WHERE ([stuNO] = @stuNO)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox2" Name="stuNO" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        </asp:Content>
